package com.leesche.zcsp.node.web.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class PUBConsumptionCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public PUBConsumptionCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andConsumptionidIsNull() {
            addCriterion("ConsumptionID is null");
            return (Criteria) this;
        }

        public Criteria andConsumptionidIsNotNull() {
            addCriterion("ConsumptionID is not null");
            return (Criteria) this;
        }

        public Criteria andConsumptionidEqualTo(Long value) {
            addCriterion("ConsumptionID =", value, "consumptionid");
            return (Criteria) this;
        }

        public Criteria andConsumptionidNotEqualTo(Long value) {
            addCriterion("ConsumptionID <>", value, "consumptionid");
            return (Criteria) this;
        }

        public Criteria andConsumptionidGreaterThan(Long value) {
            addCriterion("ConsumptionID >", value, "consumptionid");
            return (Criteria) this;
        }

        public Criteria andConsumptionidGreaterThanOrEqualTo(Long value) {
            addCriterion("ConsumptionID >=", value, "consumptionid");
            return (Criteria) this;
        }

        public Criteria andConsumptionidLessThan(Long value) {
            addCriterion("ConsumptionID <", value, "consumptionid");
            return (Criteria) this;
        }

        public Criteria andConsumptionidLessThanOrEqualTo(Long value) {
            addCriterion("ConsumptionID <=", value, "consumptionid");
            return (Criteria) this;
        }

        public Criteria andConsumptionidIn(List<Long> values) {
            addCriterion("ConsumptionID in", values, "consumptionid");
            return (Criteria) this;
        }

        public Criteria andConsumptionidNotIn(List<Long> values) {
            addCriterion("ConsumptionID not in", values, "consumptionid");
            return (Criteria) this;
        }

        public Criteria andConsumptionidBetween(Long value1, Long value2) {
            addCriterion("ConsumptionID between", value1, value2, "consumptionid");
            return (Criteria) this;
        }

        public Criteria andConsumptionidNotBetween(Long value1, Long value2) {
            addCriterion("ConsumptionID not between", value1, value2, "consumptionid");
            return (Criteria) this;
        }

        public Criteria andMemberidIsNull() {
            addCriterion("memberID is null");
            return (Criteria) this;
        }

        public Criteria andMemberidIsNotNull() {
            addCriterion("memberID is not null");
            return (Criteria) this;
        }

        public Criteria andMemberidEqualTo(Long value) {
            addCriterion("memberID =", value, "memberid");
            return (Criteria) this;
        }

        public Criteria andMemberidNotEqualTo(Long value) {
            addCriterion("memberID <>", value, "memberid");
            return (Criteria) this;
        }

        public Criteria andMemberidGreaterThan(Long value) {
            addCriterion("memberID >", value, "memberid");
            return (Criteria) this;
        }

        public Criteria andMemberidGreaterThanOrEqualTo(Long value) {
            addCriterion("memberID >=", value, "memberid");
            return (Criteria) this;
        }

        public Criteria andMemberidLessThan(Long value) {
            addCriterion("memberID <", value, "memberid");
            return (Criteria) this;
        }

        public Criteria andMemberidLessThanOrEqualTo(Long value) {
            addCriterion("memberID <=", value, "memberid");
            return (Criteria) this;
        }

        public Criteria andMemberidIn(List<Long> values) {
            addCriterion("memberID in", values, "memberid");
            return (Criteria) this;
        }

        public Criteria andMemberidNotIn(List<Long> values) {
            addCriterion("memberID not in", values, "memberid");
            return (Criteria) this;
        }

        public Criteria andMemberidBetween(Long value1, Long value2) {
            addCriterion("memberID between", value1, value2, "memberid");
            return (Criteria) this;
        }

        public Criteria andMemberidNotBetween(Long value1, Long value2) {
            addCriterion("memberID not between", value1, value2, "memberid");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andPlaceidIsNull() {
            addCriterion("placeId is null");
            return (Criteria) this;
        }

        public Criteria andPlaceidIsNotNull() {
            addCriterion("placeId is not null");
            return (Criteria) this;
        }

        public Criteria andPlaceidEqualTo(Long value) {
            addCriterion("placeId =", value, "placeid");
            return (Criteria) this;
        }

        public Criteria andPlaceidNotEqualTo(Long value) {
            addCriterion("placeId <>", value, "placeid");
            return (Criteria) this;
        }

        public Criteria andPlaceidGreaterThan(Long value) {
            addCriterion("placeId >", value, "placeid");
            return (Criteria) this;
        }

        public Criteria andPlaceidGreaterThanOrEqualTo(Long value) {
            addCriterion("placeId >=", value, "placeid");
            return (Criteria) this;
        }

        public Criteria andPlaceidLessThan(Long value) {
            addCriterion("placeId <", value, "placeid");
            return (Criteria) this;
        }

        public Criteria andPlaceidLessThanOrEqualTo(Long value) {
            addCriterion("placeId <=", value, "placeid");
            return (Criteria) this;
        }

        public Criteria andPlaceidIn(List<Long> values) {
            addCriterion("placeId in", values, "placeid");
            return (Criteria) this;
        }

        public Criteria andPlaceidNotIn(List<Long> values) {
            addCriterion("placeId not in", values, "placeid");
            return (Criteria) this;
        }

        public Criteria andPlaceidBetween(Long value1, Long value2) {
            addCriterion("placeId between", value1, value2, "placeid");
            return (Criteria) this;
        }

        public Criteria andPlaceidNotBetween(Long value1, Long value2) {
            addCriterion("placeId not between", value1, value2, "placeid");
            return (Criteria) this;
        }

        public Criteria andPlacenameIsNull() {
            addCriterion("placeName is null");
            return (Criteria) this;
        }

        public Criteria andPlacenameIsNotNull() {
            addCriterion("placeName is not null");
            return (Criteria) this;
        }

        public Criteria andPlacenameEqualTo(String value) {
            addCriterion("placeName =", value, "placename");
            return (Criteria) this;
        }

        public Criteria andPlacenameNotEqualTo(String value) {
            addCriterion("placeName <>", value, "placename");
            return (Criteria) this;
        }

        public Criteria andPlacenameGreaterThan(String value) {
            addCriterion("placeName >", value, "placename");
            return (Criteria) this;
        }

        public Criteria andPlacenameGreaterThanOrEqualTo(String value) {
            addCriterion("placeName >=", value, "placename");
            return (Criteria) this;
        }

        public Criteria andPlacenameLessThan(String value) {
            addCriterion("placeName <", value, "placename");
            return (Criteria) this;
        }

        public Criteria andPlacenameLessThanOrEqualTo(String value) {
            addCriterion("placeName <=", value, "placename");
            return (Criteria) this;
        }

        public Criteria andPlacenameLike(String value) {
            addCriterion("placeName like", value, "placename");
            return (Criteria) this;
        }

        public Criteria andPlacenameNotLike(String value) {
            addCriterion("placeName not like", value, "placename");
            return (Criteria) this;
        }

        public Criteria andPlacenameIn(List<String> values) {
            addCriterion("placeName in", values, "placename");
            return (Criteria) this;
        }

        public Criteria andPlacenameNotIn(List<String> values) {
            addCriterion("placeName not in", values, "placename");
            return (Criteria) this;
        }

        public Criteria andPlacenameBetween(String value1, String value2) {
            addCriterion("placeName between", value1, value2, "placename");
            return (Criteria) this;
        }

        public Criteria andPlacenameNotBetween(String value1, String value2) {
            addCriterion("placeName not between", value1, value2, "placename");
            return (Criteria) this;
        }

        public Criteria andDeviceidIsNull() {
            addCriterion("deviceId is null");
            return (Criteria) this;
        }

        public Criteria andDeviceidIsNotNull() {
            addCriterion("deviceId is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceidEqualTo(Long value) {
            addCriterion("deviceId =", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidNotEqualTo(Long value) {
            addCriterion("deviceId <>", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidGreaterThan(Long value) {
            addCriterion("deviceId >", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidGreaterThanOrEqualTo(Long value) {
            addCriterion("deviceId >=", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidLessThan(Long value) {
            addCriterion("deviceId <", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidLessThanOrEqualTo(Long value) {
            addCriterion("deviceId <=", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidIn(List<Long> values) {
            addCriterion("deviceId in", values, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidNotIn(List<Long> values) {
            addCriterion("deviceId not in", values, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidBetween(Long value1, Long value2) {
            addCriterion("deviceId between", value1, value2, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidNotBetween(Long value1, Long value2) {
            addCriterion("deviceId not between", value1, value2, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDevicenameIsNull() {
            addCriterion("deviceName is null");
            return (Criteria) this;
        }

        public Criteria andDevicenameIsNotNull() {
            addCriterion("deviceName is not null");
            return (Criteria) this;
        }

        public Criteria andDevicenameEqualTo(String value) {
            addCriterion("deviceName =", value, "devicename");
            return (Criteria) this;
        }

        public Criteria andDevicenameNotEqualTo(String value) {
            addCriterion("deviceName <>", value, "devicename");
            return (Criteria) this;
        }

        public Criteria andDevicenameGreaterThan(String value) {
            addCriterion("deviceName >", value, "devicename");
            return (Criteria) this;
        }

        public Criteria andDevicenameGreaterThanOrEqualTo(String value) {
            addCriterion("deviceName >=", value, "devicename");
            return (Criteria) this;
        }

        public Criteria andDevicenameLessThan(String value) {
            addCriterion("deviceName <", value, "devicename");
            return (Criteria) this;
        }

        public Criteria andDevicenameLessThanOrEqualTo(String value) {
            addCriterion("deviceName <=", value, "devicename");
            return (Criteria) this;
        }

        public Criteria andDevicenameLike(String value) {
            addCriterion("deviceName like", value, "devicename");
            return (Criteria) this;
        }

        public Criteria andDevicenameNotLike(String value) {
            addCriterion("deviceName not like", value, "devicename");
            return (Criteria) this;
        }

        public Criteria andDevicenameIn(List<String> values) {
            addCriterion("deviceName in", values, "devicename");
            return (Criteria) this;
        }

        public Criteria andDevicenameNotIn(List<String> values) {
            addCriterion("deviceName not in", values, "devicename");
            return (Criteria) this;
        }

        public Criteria andDevicenameBetween(String value1, String value2) {
            addCriterion("deviceName between", value1, value2, "devicename");
            return (Criteria) this;
        }

        public Criteria andDevicenameNotBetween(String value1, String value2) {
            addCriterion("deviceName not between", value1, value2, "devicename");
            return (Criteria) this;
        }

        public Criteria andCtypeIsNull() {
            addCriterion("cType is null");
            return (Criteria) this;
        }

        public Criteria andCtypeIsNotNull() {
            addCriterion("cType is not null");
            return (Criteria) this;
        }

        public Criteria andCtypeEqualTo(Integer value) {
            addCriterion("cType =", value, "ctype");
            return (Criteria) this;
        }

        public Criteria andCtypeNotEqualTo(Integer value) {
            addCriterion("cType <>", value, "ctype");
            return (Criteria) this;
        }

        public Criteria andCtypeGreaterThan(Integer value) {
            addCriterion("cType >", value, "ctype");
            return (Criteria) this;
        }

        public Criteria andCtypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("cType >=", value, "ctype");
            return (Criteria) this;
        }

        public Criteria andCtypeLessThan(Integer value) {
            addCriterion("cType <", value, "ctype");
            return (Criteria) this;
        }

        public Criteria andCtypeLessThanOrEqualTo(Integer value) {
            addCriterion("cType <=", value, "ctype");
            return (Criteria) this;
        }

        public Criteria andCtypeIn(List<Integer> values) {
            addCriterion("cType in", values, "ctype");
            return (Criteria) this;
        }

        public Criteria andCtypeNotIn(List<Integer> values) {
            addCriterion("cType not in", values, "ctype");
            return (Criteria) this;
        }

        public Criteria andCtypeBetween(Integer value1, Integer value2) {
            addCriterion("cType between", value1, value2, "ctype");
            return (Criteria) this;
        }

        public Criteria andCtypeNotBetween(Integer value1, Integer value2) {
            addCriterion("cType not between", value1, value2, "ctype");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNull() {
            addCriterion("quantity is null");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNotNull() {
            addCriterion("quantity is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityEqualTo(Integer value) {
            addCriterion("quantity =", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotEqualTo(Integer value) {
            addCriterion("quantity <>", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThan(Integer value) {
            addCriterion("quantity >", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity >=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThan(Integer value) {
            addCriterion("quantity <", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThanOrEqualTo(Integer value) {
            addCriterion("quantity <=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityIn(List<Integer> values) {
            addCriterion("quantity in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotIn(List<Integer> values) {
            addCriterion("quantity not in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityBetween(Integer value1, Integer value2) {
            addCriterion("quantity between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity not between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andCoinIsNull() {
            addCriterion("Coin is null");
            return (Criteria) this;
        }

        public Criteria andCoinIsNotNull() {
            addCriterion("Coin is not null");
            return (Criteria) this;
        }

        public Criteria andCoinEqualTo(Integer value) {
            addCriterion("Coin =", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinNotEqualTo(Integer value) {
            addCriterion("Coin <>", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinGreaterThan(Integer value) {
            addCriterion("Coin >", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinGreaterThanOrEqualTo(Integer value) {
            addCriterion("Coin >=", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinLessThan(Integer value) {
            addCriterion("Coin <", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinLessThanOrEqualTo(Integer value) {
            addCriterion("Coin <=", value, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinIn(List<Integer> values) {
            addCriterion("Coin in", values, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinNotIn(List<Integer> values) {
            addCriterion("Coin not in", values, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinBetween(Integer value1, Integer value2) {
            addCriterion("Coin between", value1, value2, "coin");
            return (Criteria) this;
        }

        public Criteria andCoinNotBetween(Integer value1, Integer value2) {
            addCriterion("Coin not between", value1, value2, "coin");
            return (Criteria) this;
        }

        public Criteria andResultIsNull() {
            addCriterion("result is null");
            return (Criteria) this;
        }

        public Criteria andResultIsNotNull() {
            addCriterion("result is not null");
            return (Criteria) this;
        }

        public Criteria andResultEqualTo(Integer value) {
            addCriterion("result =", value, "result");
            return (Criteria) this;
        }

        public Criteria andResultNotEqualTo(Integer value) {
            addCriterion("result <>", value, "result");
            return (Criteria) this;
        }

        public Criteria andResultGreaterThan(Integer value) {
            addCriterion("result >", value, "result");
            return (Criteria) this;
        }

        public Criteria andResultGreaterThanOrEqualTo(Integer value) {
            addCriterion("result >=", value, "result");
            return (Criteria) this;
        }

        public Criteria andResultLessThan(Integer value) {
            addCriterion("result <", value, "result");
            return (Criteria) this;
        }

        public Criteria andResultLessThanOrEqualTo(Integer value) {
            addCriterion("result <=", value, "result");
            return (Criteria) this;
        }

        public Criteria andResultIn(List<Integer> values) {
            addCriterion("result in", values, "result");
            return (Criteria) this;
        }

        public Criteria andResultNotIn(List<Integer> values) {
            addCriterion("result not in", values, "result");
            return (Criteria) this;
        }

        public Criteria andResultBetween(Integer value1, Integer value2) {
            addCriterion("result between", value1, value2, "result");
            return (Criteria) this;
        }

        public Criteria andResultNotBetween(Integer value1, Integer value2) {
            addCriterion("result not between", value1, value2, "result");
            return (Criteria) this;
        }

        public Criteria andResulttextIsNull() {
            addCriterion("resultText is null");
            return (Criteria) this;
        }

        public Criteria andResulttextIsNotNull() {
            addCriterion("resultText is not null");
            return (Criteria) this;
        }

        public Criteria andResulttextEqualTo(String value) {
            addCriterion("resultText =", value, "resulttext");
            return (Criteria) this;
        }

        public Criteria andResulttextNotEqualTo(String value) {
            addCriterion("resultText <>", value, "resulttext");
            return (Criteria) this;
        }

        public Criteria andResulttextGreaterThan(String value) {
            addCriterion("resultText >", value, "resulttext");
            return (Criteria) this;
        }

        public Criteria andResulttextGreaterThanOrEqualTo(String value) {
            addCriterion("resultText >=", value, "resulttext");
            return (Criteria) this;
        }

        public Criteria andResulttextLessThan(String value) {
            addCriterion("resultText <", value, "resulttext");
            return (Criteria) this;
        }

        public Criteria andResulttextLessThanOrEqualTo(String value) {
            addCriterion("resultText <=", value, "resulttext");
            return (Criteria) this;
        }

        public Criteria andResulttextLike(String value) {
            addCriterion("resultText like", value, "resulttext");
            return (Criteria) this;
        }

        public Criteria andResulttextNotLike(String value) {
            addCriterion("resultText not like", value, "resulttext");
            return (Criteria) this;
        }

        public Criteria andResulttextIn(List<String> values) {
            addCriterion("resultText in", values, "resulttext");
            return (Criteria) this;
        }

        public Criteria andResulttextNotIn(List<String> values) {
            addCriterion("resultText not in", values, "resulttext");
            return (Criteria) this;
        }

        public Criteria andResulttextBetween(String value1, String value2) {
            addCriterion("resultText between", value1, value2, "resulttext");
            return (Criteria) this;
        }

        public Criteria andResulttextNotBetween(String value1, String value2) {
            addCriterion("resultText not between", value1, value2, "resulttext");
            return (Criteria) this;
        }

        public Criteria andChecktimeIsNull() {
            addCriterion("checkTime is null");
            return (Criteria) this;
        }

        public Criteria andChecktimeIsNotNull() {
            addCriterion("checkTime is not null");
            return (Criteria) this;
        }

        public Criteria andChecktimeEqualTo(Long value) {
            addCriterion("checkTime =", value, "checktime");
            return (Criteria) this;
        }

        public Criteria andChecktimeNotEqualTo(Long value) {
            addCriterion("checkTime <>", value, "checktime");
            return (Criteria) this;
        }

        public Criteria andChecktimeGreaterThan(Long value) {
            addCriterion("checkTime >", value, "checktime");
            return (Criteria) this;
        }

        public Criteria andChecktimeGreaterThanOrEqualTo(Long value) {
            addCriterion("checkTime >=", value, "checktime");
            return (Criteria) this;
        }

        public Criteria andChecktimeLessThan(Long value) {
            addCriterion("checkTime <", value, "checktime");
            return (Criteria) this;
        }

        public Criteria andChecktimeLessThanOrEqualTo(Long value) {
            addCriterion("checkTime <=", value, "checktime");
            return (Criteria) this;
        }

        public Criteria andChecktimeIn(List<Long> values) {
            addCriterion("checkTime in", values, "checktime");
            return (Criteria) this;
        }

        public Criteria andChecktimeNotIn(List<Long> values) {
            addCriterion("checkTime not in", values, "checktime");
            return (Criteria) this;
        }

        public Criteria andChecktimeBetween(Long value1, Long value2) {
            addCriterion("checkTime between", value1, value2, "checktime");
            return (Criteria) this;
        }

        public Criteria andChecktimeNotBetween(Long value1, Long value2) {
            addCriterion("checkTime not between", value1, value2, "checktime");
            return (Criteria) this;
        }

        public Criteria andSdata1IsNull() {
            addCriterion("sData1 is null");
            return (Criteria) this;
        }

        public Criteria andSdata1IsNotNull() {
            addCriterion("sData1 is not null");
            return (Criteria) this;
        }

        public Criteria andSdata1EqualTo(String value) {
            addCriterion("sData1 =", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1NotEqualTo(String value) {
            addCriterion("sData1 <>", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1GreaterThan(String value) {
            addCriterion("sData1 >", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1GreaterThanOrEqualTo(String value) {
            addCriterion("sData1 >=", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1LessThan(String value) {
            addCriterion("sData1 <", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1LessThanOrEqualTo(String value) {
            addCriterion("sData1 <=", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1Like(String value) {
            addCriterion("sData1 like", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1NotLike(String value) {
            addCriterion("sData1 not like", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1In(List<String> values) {
            addCriterion("sData1 in", values, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1NotIn(List<String> values) {
            addCriterion("sData1 not in", values, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1Between(String value1, String value2) {
            addCriterion("sData1 between", value1, value2, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1NotBetween(String value1, String value2) {
            addCriterion("sData1 not between", value1, value2, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata9IsNull() {
            addCriterion("sData9 is null");
            return (Criteria) this;
        }

        public Criteria andSdata9IsNotNull() {
            addCriterion("sData9 is not null");
            return (Criteria) this;
        }

        public Criteria andSdata9EqualTo(String value) {
            addCriterion("sData9 =", value, "sdata9");
            return (Criteria) this;
        }

        public Criteria andSdata9NotEqualTo(String value) {
            addCriterion("sData9 <>", value, "sdata9");
            return (Criteria) this;
        }

        public Criteria andSdata9GreaterThan(String value) {
            addCriterion("sData9 >", value, "sdata9");
            return (Criteria) this;
        }

        public Criteria andSdata9GreaterThanOrEqualTo(String value) {
            addCriterion("sData9 >=", value, "sdata9");
            return (Criteria) this;
        }

        public Criteria andSdata9LessThan(String value) {
            addCriterion("sData9 <", value, "sdata9");
            return (Criteria) this;
        }

        public Criteria andSdata9LessThanOrEqualTo(String value) {
            addCriterion("sData9 <=", value, "sdata9");
            return (Criteria) this;
        }

        public Criteria andSdata9Like(String value) {
            addCriterion("sData9 like", value, "sdata9");
            return (Criteria) this;
        }

        public Criteria andSdata9NotLike(String value) {
            addCriterion("sData9 not like", value, "sdata9");
            return (Criteria) this;
        }

        public Criteria andSdata9In(List<String> values) {
            addCriterion("sData9 in", values, "sdata9");
            return (Criteria) this;
        }

        public Criteria andSdata9NotIn(List<String> values) {
            addCriterion("sData9 not in", values, "sdata9");
            return (Criteria) this;
        }

        public Criteria andSdata9Between(String value1, String value2) {
            addCriterion("sData9 between", value1, value2, "sdata9");
            return (Criteria) this;
        }

        public Criteria andSdata9NotBetween(String value1, String value2) {
            addCriterion("sData9 not between", value1, value2, "sdata9");
            return (Criteria) this;
        }

        public Criteria andSdata3IsNull() {
            addCriterion("sData3 is null");
            return (Criteria) this;
        }

        public Criteria andSdata3IsNotNull() {
            addCriterion("sData3 is not null");
            return (Criteria) this;
        }

        public Criteria andSdata3EqualTo(String value) {
            addCriterion("sData3 =", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3NotEqualTo(String value) {
            addCriterion("sData3 <>", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3GreaterThan(String value) {
            addCriterion("sData3 >", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3GreaterThanOrEqualTo(String value) {
            addCriterion("sData3 >=", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3LessThan(String value) {
            addCriterion("sData3 <", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3LessThanOrEqualTo(String value) {
            addCriterion("sData3 <=", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3Like(String value) {
            addCriterion("sData3 like", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3NotLike(String value) {
            addCriterion("sData3 not like", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3In(List<String> values) {
            addCriterion("sData3 in", values, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3NotIn(List<String> values) {
            addCriterion("sData3 not in", values, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3Between(String value1, String value2) {
            addCriterion("sData3 between", value1, value2, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3NotBetween(String value1, String value2) {
            addCriterion("sData3 not between", value1, value2, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata4IsNull() {
            addCriterion("sData4 is null");
            return (Criteria) this;
        }

        public Criteria andSdata4IsNotNull() {
            addCriterion("sData4 is not null");
            return (Criteria) this;
        }

        public Criteria andSdata4EqualTo(String value) {
            addCriterion("sData4 =", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4NotEqualTo(String value) {
            addCriterion("sData4 <>", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4GreaterThan(String value) {
            addCriterion("sData4 >", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4GreaterThanOrEqualTo(String value) {
            addCriterion("sData4 >=", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4LessThan(String value) {
            addCriterion("sData4 <", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4LessThanOrEqualTo(String value) {
            addCriterion("sData4 <=", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4Like(String value) {
            addCriterion("sData4 like", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4NotLike(String value) {
            addCriterion("sData4 not like", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4In(List<String> values) {
            addCriterion("sData4 in", values, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4NotIn(List<String> values) {
            addCriterion("sData4 not in", values, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4Between(String value1, String value2) {
            addCriterion("sData4 between", value1, value2, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4NotBetween(String value1, String value2) {
            addCriterion("sData4 not between", value1, value2, "sdata4");
            return (Criteria) this;
        }

        public Criteria andIdata1IsNull() {
            addCriterion("iData1 is null");
            return (Criteria) this;
        }

        public Criteria andIdata1IsNotNull() {
            addCriterion("iData1 is not null");
            return (Criteria) this;
        }

        public Criteria andIdata1EqualTo(Integer value) {
            addCriterion("iData1 =", value, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1NotEqualTo(Integer value) {
            addCriterion("iData1 <>", value, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1GreaterThan(Integer value) {
            addCriterion("iData1 >", value, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1GreaterThanOrEqualTo(Integer value) {
            addCriterion("iData1 >=", value, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1LessThan(Integer value) {
            addCriterion("iData1 <", value, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1LessThanOrEqualTo(Integer value) {
            addCriterion("iData1 <=", value, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1In(List<Integer> values) {
            addCriterion("iData1 in", values, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1NotIn(List<Integer> values) {
            addCriterion("iData1 not in", values, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1Between(Integer value1, Integer value2) {
            addCriterion("iData1 between", value1, value2, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1NotBetween(Integer value1, Integer value2) {
            addCriterion("iData1 not between", value1, value2, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata2IsNull() {
            addCriterion("idata2 is null");
            return (Criteria) this;
        }

        public Criteria andIdata2IsNotNull() {
            addCriterion("idata2 is not null");
            return (Criteria) this;
        }

        public Criteria andIdata2EqualTo(Integer value) {
            addCriterion("idata2 =", value, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2NotEqualTo(Integer value) {
            addCriterion("idata2 <>", value, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2GreaterThan(Integer value) {
            addCriterion("idata2 >", value, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2GreaterThanOrEqualTo(Integer value) {
            addCriterion("idata2 >=", value, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2LessThan(Integer value) {
            addCriterion("idata2 <", value, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2LessThanOrEqualTo(Integer value) {
            addCriterion("idata2 <=", value, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2In(List<Integer> values) {
            addCriterion("idata2 in", values, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2NotIn(List<Integer> values) {
            addCriterion("idata2 not in", values, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2Between(Integer value1, Integer value2) {
            addCriterion("idata2 between", value1, value2, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2NotBetween(Integer value1, Integer value2) {
            addCriterion("idata2 not between", value1, value2, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata3IsNull() {
            addCriterion("idata3 is null");
            return (Criteria) this;
        }

        public Criteria andIdata3IsNotNull() {
            addCriterion("idata3 is not null");
            return (Criteria) this;
        }

        public Criteria andIdata3EqualTo(Integer value) {
            addCriterion("idata3 =", value, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3NotEqualTo(Integer value) {
            addCriterion("idata3 <>", value, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3GreaterThan(Integer value) {
            addCriterion("idata3 >", value, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3GreaterThanOrEqualTo(Integer value) {
            addCriterion("idata3 >=", value, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3LessThan(Integer value) {
            addCriterion("idata3 <", value, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3LessThanOrEqualTo(Integer value) {
            addCriterion("idata3 <=", value, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3In(List<Integer> values) {
            addCriterion("idata3 in", values, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3NotIn(List<Integer> values) {
            addCriterion("idata3 not in", values, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3Between(Integer value1, Integer value2) {
            addCriterion("idata3 between", value1, value2, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3NotBetween(Integer value1, Integer value2) {
            addCriterion("idata3 not between", value1, value2, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata4IsNull() {
            addCriterion("idata4 is null");
            return (Criteria) this;
        }

        public Criteria andIdata4IsNotNull() {
            addCriterion("idata4 is not null");
            return (Criteria) this;
        }

        public Criteria andIdata4EqualTo(Integer value) {
            addCriterion("idata4 =", value, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4NotEqualTo(Integer value) {
            addCriterion("idata4 <>", value, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4GreaterThan(Integer value) {
            addCriterion("idata4 >", value, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4GreaterThanOrEqualTo(Integer value) {
            addCriterion("idata4 >=", value, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4LessThan(Integer value) {
            addCriterion("idata4 <", value, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4LessThanOrEqualTo(Integer value) {
            addCriterion("idata4 <=", value, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4In(List<Integer> values) {
            addCriterion("idata4 in", values, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4NotIn(List<Integer> values) {
            addCriterion("idata4 not in", values, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4Between(Integer value1, Integer value2) {
            addCriterion("idata4 between", value1, value2, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4NotBetween(Integer value1, Integer value2) {
            addCriterion("idata4 not between", value1, value2, "idata4");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}